SWTS GEO GPS Android

Source of data and the following data description: https://archive.ics.uci.edu/ml/datasets/GPS+Trajectories.

Data Abstract: The dataset has been feed by Android app called Go!Track. It is available at Goolge Play Store.

Get the GPS Activity Data

Source of data and the following data description: https://archive.ics.uci.edu/ml/datasets/GPS+Trajectories.

Data Set Information:

The dataset is composed by two tables. The first table go_track_tracks presents general attributes and each instance has one trajectory that is represented by the table go_track_trackspoints.

Attribute Information:

1. go_track_tracks.csv: a list of trajectories

• id_android - it represents the device used to capture the instance;
• speed - it represents the average speed (Km/H)
• distance - it represent the total distance (Km)
• rating - it is an evaluation parameter. Evaluation the traffic is a way to verify the volunteers perception about the traffic during the travel, in other words, if volunteers move to some place and face traffic jam, maybe they will evaluate ‘bad’. (3- good, 2- normal, 1-bad).
• rating_bus - it is other evaluation parameter. (1 - The amount of people inside the bus is little, 2 - The bus is not crowded, 3- The bus is crowded.
• rating_weather - it is another evaluation parameter. ( 2- sunny, 1- raining).
• car_or_bus - (1 - car, 2-bus)
• linha - information about the bus that does the pathway

2. go_track_trackspoints.csv: localization points of each trajectory

• id: unique key to identify each point
• latitude: latitude from where the point is
• longitude: longitude from where the point is
• track_id: identify the trajectory which the point belong
• time: datetime when the point was collected (GMT-3)

Data table for Tracks data:

This data table links the user to the actual GPS track. Provides information such as users, speeds, mode of transportation, and weather.

id	id_android	speed	time	distance	rating	rating_bus	rating_weather	car_or_bus	linha
1	0	19.210586	0.1380489	2.652	3	0	0	1
2	0	30.848229	0.1714847	5.290	3	0	0	1
3	1	13.560101	0.0676986	0.918	3	0	0	2
4	1	19.766679	0.3895444	7.700	3	0	0	2
8	0	25.807401	0.1548006	3.995	2	0	0	1
10	2	1.346913	0.0066819	0.009	2	0	0	1

Data table for Points data:

This data table contains all of the GPS tracks for the 28 Android users. Provides date, time, and locations.

id	latitude	longitude	track_id	time
1	-10.93934	-37.06274	1	2014-09-13 07:24:32
2	-10.93934	-37.06274	1	2014-09-13 07:24:37
3	-10.93932	-37.06276	1	2014-09-13 07:24:42
4	-10.93921	-37.06284	1	2014-09-13 07:24:47
5	-10.93894	-37.06288	1	2014-09-13 07:24:53
6	-10.93854	-37.06284	1	2014-09-13 07:24:59

Combine data:

The data is combined/joined by the user ID to achieve a complete data set of analysis.

id	user	lat	lon	date_time
1	1	-10.93934	-37.06274	2014-09-13 07:24:32
1	1	-10.93934	-37.06274	2014-09-13 07:24:37
1	1	-10.93932	-37.06276	2014-09-13 07:24:42
1	1	-10.93921	-37.06284	2014-09-13 07:24:47
1	1	-10.93894	-37.06288	2014-09-13 07:24:53
1	1	-10.93854	-37.06284	2014-09-13 07:24:59

Initial Map Plot of All Android Tracks

The above map is too busy, we have to refine the information we are looking to garner. For example, we are looking for users that could have made contact on 29 May 2015. Who are they? Where were they likely to meet?

Refined Android Plot of Tracks (leaflet)

Refined Android Plot of Tracks (ggmap)